﻿url = "https://www.iyxwzx.com/yinshi/"
this_number = 3
if this_number == 0:
#~~~~~~Browser_and_Sql_Parameters~~~~~~#
    executable_path = r"C:\Users\Yu\Desktop\BullShit\Python\selenium\geckodriver"
    firefox_profile = r"C:\Users\Yu\AppData\Roaming\Mozilla\Firefox\Profiles\hehir24f.default-release-1588927760478"
    sql_driver = '{ODBC driver 17 for SQL Server}'
    server = 'Yu-GODS-LAPTOP'
    database= 'Project'
    trusted_connection = 'yes'
    uid = ''
    pwd = ''
    port = ""
    table = 'Project.dbo.ET_InvestNews'
    table_tag = 'Project.dbo.ET_InvestTags'
    table_relation_0 = 'Project.dbo.ET_InvestNewsToEnterprise'
    table_relation_1 = 'Project.dbo.ET_InvestRelationEnterprise'
    table_img = 'Project.dbo.ET_InvestImg'
#~~~~~~Browser_and_Sql_Parameters~~~~~~#~~~~~~65~~~~~~#
elif this_number == 1:
    executable_path = r"C:\Users\Administrator\Desktop\InvestNewsTrail\geckodriver"
    firefox_profile = r"C:\Users\Administrator\AppData\Roaming\Mozilla\Firefox\Profiles\9r563ysn.default-release"
    sql_driver = '{ODBC driver 17 for SQL Server}'
    server = 'ECS-2566' 
    database = 'ProjectManager'
    trusted_connection = 'yes'
    uid = 'teda2020'  
    pwd = 'App1234.ww'
    port = ""
    table = 'ProjectManager.dbo.ET_InvestNews'
    table_tag = 'ProjectManager.dbo.ET_InvestTags'
    table_relation_0 = 'ProjectManager.dbo.ET_InvestNewsToEnterprise'
    table_relation_1 = 'ProjectManager.dbo.ET_InvestRelationEnterprise'
    table_img = 'ProjectManager.dbo.ET_InvestImg'
#~~~~~~Browser_and_Sql_Parameters~~~~~~#~~~~~~81~~~~~~#
elif this_number == 2:
    executable_path = r"F:\InvestNews\InvestNews\geckodriver\geckodriver"
    firefox_profile = r"C:\Users\ETwebadmin03\AppData\Roaming\Mozilla\Firefox\Profiles\nv1wnnvi.default-release"
    sql_driver = '{ODBC driver 17 for SQL Server}'
    server = '192.168.85.51,1789' 
    database = 'Test0620'
    trusted_connection = 'no'
    uid = 'sa'  
    pwd = 'App1234'
    port = '1433'
    table = 'Test0620.dbo.ET_InvestNews'
    table_tag = 'Test0620.dbo.ET_InvestTags'
    table_relation_0 = 'Test0620.dbo.ET_InvestNewsToEnterprise'
    table_relation_1 = 'Test0620.dbo.ET_InvestRelationEnterprise'
    table_img = 'Test0620.dbo.ET_InvestImg'
elif this_number == 3:
    executable_path = r"F:\InvestNews\InvestNews_0\geckodriver\geckodriver"
    firefox_profile = r"C:\Users\ETwebadmin03\AppData\Roaming\Mozilla\Firefox\Profiles\nv1wnnvi.default-release"
    sql_driver = '{ODBC driver 17 for SQL Server}'
    server = '192.168.85.51,1789' 
    database = 'ET_dbForEN'
    trusted_connection = 'no'
    uid = 'sa'  
    pwd = 'App1234'
    port = '1433'
    table = 'ET_dbForEN.dbo.ET_InvestNews'
    table_tag = 'ET_dbForEN.dbo.ET_InvestTags'
    table_relation_0 = 'ET_dbForEN.dbo.ET_InvestNewsToEnterprise'
    table_relation_1 = 'ET_dbForEN.dbo.ET_InvestRelationEnterprise'
    table_img = 'ET_dbForEN.dbo.ET_InvestImg'



#~~~~~~BasicInfo_Variables~~~~~~#
limit = 5
targets_parent_selector = "body > div.wrap-b.pt-20.pb-40 > div.wrap.clearfix.main > div.left.fl > div.two-list > div"
targets_set_locate_method = "class"
targets_set_tag_name = ""
targets_set_class_name = "ls-typetwo  b-b-dashed clearfix pb-20"
targets_location_method = "class"
targets_tag_name = ""
targets_class_name = "a-hover"
link_title_relation = "link_title_under_target_same"
keep_pub_time = "false"
pub_time_elem_locate_method = ""
pub_time_class = ""
pub_time_tag = ""
pub_time_locate_method = ""
pub_time_attribute_name = ""
link_elem_x_path_level = 1
title_tag_name = "a"
link_tag_name = "a"
link_attribute_name = "href"
title_locate_method = "text"
title_attribute_name = ""
#~~~~~~GetContent_Varables~~~~~~#
title_selector = "body > div.wrap-b.pt-20.pb-40 > div.wrap.clearfix.main.main-relative > div.left.fl > div.arti > div.arti-head > h1"
title_exception = "false"
title_exception_solution = ""
article_parent_selector = "body > div.wrap-b.pt-20.pb-40 > div.wrap.clearfix.main.main-relative > div.left.fl > div.arti > div.arti-content > table > tbody > tr > td"
article_elem_single = "false"
article_elem_locate_method = ""
article_elem_class = ""
article_filter = "false"
article_filter_key = ""
article_elem_start_index = 1
pub_time_parent_selector = ""
pub_time_exact = r"(\d+)-(\d+)-(\d+) (\d+):(\d+):\d+" #in format "year-month-day hour:minute"
pub_time_sibling_para = "false"
pub_time_selector = "body > div.wrap-b.pt-20.pb-40 > div.wrap.clearfix.main.main-relative > div.left.fl > div.arti > div.arti-head > div > span.fl.arti-hi-left"
pub_time_exception_key = "None"
img_input_exception = "false"
img_input_exception_solution = ""
img_filter = "false"
img_filter_key = ""
#~~~~~~Uniform_Parameters~~~~~~#
source = "益经济-科技"
create_user = "Admin"
flag = "4"
status = "1"
bak1 = "170"
source_id = "9"
